from pymysql import connect

conn = connect(user='root', password='123456', host='192.168.233.129', database='eshop', port=3306)
cursor = conn.cursor()
sql='select id,title from es_floor;'
cursor.execute(sql)
result=cursor.fetchall()
print(result)

cursor.close()
conn.close()